Introduction of SQL server
Install SQL Server And SQL Server Management Studio
Create, Rename, and Delete Database
Create, Delete and rename table in SQL server database
Add, Rename And Delete column name
Records insert, update & delete
Select statement
Select Unique and Distinct statement
Select into statement
Insert, update and delete statement
Aggregate function count, max, min, sum, avg
What are SQL Joins
Introduction to Group by Clause
Introduction to Having Clause
Introduction to Order by clause
Introduction to Where clause
AND & OR Operator
Arithmetic Operator
Between Operator
Comparison Operator
While loop
Break and continue statement
Introduction to Stored Procedures
Select Statement Inside the Stored procedure
Insert Statement Inside a Stored Procedure
Update Statement within the Stored Procedure
Input Parameters in a Stored Procedures
Output Parameters in a Stored Procedure
Return Values in a Stored Procedure
Insert Stored Procedure output into Temporary Table
Introduction to function
Introduction to SQL View
Useful System Stored Procedures
SQL server hold the Aggregate function. Aggregate function nothing but a pre define function which are responsible to our work easy. Count function return the count of row matches a specified criteria. Max function return the maximum value of the row and min function return the minimum value of the row. Sum function return the total summation of the row that are numeric value. Avg function return the average value of the row that are numeric value of the specific row. Now given bellow the example of the SQL code:
select count(Id) from Salary
select max(Salary) from Salary
select min(Salary) from Salary
select sum(Salary) from Salary
select avg(Salary) from Salary
Now we can see our table name is Salary. This table have some column. Then first we count the table by using id column and then we find the maximum value by the salary column then find the minimum value using the Salary column. Find the sum the sum function and use the Salary column. Then we use the avg function for the find the average value of the specific column values by the Salary column.
About Teacher
Comments
